Dataset statistics
| Number of variables | 9 |
|---|---|
| Number of observations | 105840 |
| Missing cells | 3024 |
| Missing cells (%) | 0.3% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 7.3 MiB |
| Average record size in memory | 72.0 B |
Variable types
| Numeric | 2 |
|---|---|
| Categorical | 7 |
DGUID is highly overall correlated with GEO | High correlation |
GEO is highly overall correlated with DGUID | High correlation |
Indicators is highly overall correlated with UOM and 1 other fields | High correlation |
UOM is highly overall correlated with Indicators | High correlation |
SCALAR_FACTOR is highly overall correlated with Indicators | High correlation |
VALUE has 3024 (2.9%) missing values | Missing |
DGUID is uniformly distributed | Uniform |
GEO is uniformly distributed | Uniform |
Sector is uniformly distributed | Uniform |
Characteristics is uniformly distributed | Uniform |
Indicators is uniformly distributed | Uniform |
Reproduction
| Analysis started | 2023-11-27 20:36:56.149883 |
|---|---|
| Analysis finished | 2023-11-27 20:37:01.546505 |
| Duration | 5.4 seconds |
| Software version | ydata-profiling vv4.5.1 |
| Download configuration | config.json |
REF_DATE
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2015.5 |
| Minimum | 2010 |
|---|---|
| Maximum | 2021 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 827.0 KiB |
Quantile statistics
| Minimum | 2010 |
|---|---|
| 5-th percentile | 2010 |
| Q1 | 2012.75 |
| median | 2015.5 |
| Q3 | 2018.25 |
| 95-th percentile | 2021 |
| Maximum | 2021 |
| Range | 11 |
| Interquartile range (IQR) | 5.5 |
Descriptive statistics
| Standard deviation | 3.4520688 |
|---|---|
| Coefficient of variation (CV) | 0.0017127605 |
| Kurtosis | -1.216784 |
| Mean | 2015.5 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0 |
| Sum | 2.1332052 × 108 |
| Variance | 11.916779 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 2010 | 8820 | |
| 2011 | 8820 | |
| 2012 | 8820 | |
| 2013 | 8820 | |
| 2014 | 8820 | |
| 2015 | 8820 | |
| 2016 | 8820 | |
| 2017 | 8820 | |
| 2018 | 8820 | |
| 2019 | 8820 | |
| Other values (2) | 17640 |
| Value | Count | Frequency (%) |
| 2010 | 8820 | |
| 2011 | 8820 | |
| 2012 | 8820 | |
| 2013 | 8820 | |
| 2014 | 8820 | |
| 2015 | 8820 | |
| 2016 | 8820 | |
| 2017 | 8820 | |
| 2018 | 8820 | |
| 2019 | 8820 |
| Value | Count | Frequency (%) |
| 2021 | 8820 | |
| 2020 | 8820 | |
| 2019 | 8820 | |
| 2018 | 8820 | |
| 2017 | 8820 | |
| 2016 | 8820 | |
| 2015 | 8820 | |
| 2014 | 8820 | |
| 2013 | 8820 | |
| 2012 | 8820 |
DGUID
Categorical
HIGH CORRELATION UNIFORM
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 827.0 KiB |
| 2016A000011124 | |
|---|---|
| 2016A000210 | |
| 2016A000211 | |
| 2016A000212 | |
| 2016A000213 | |
| Other values (9) |
Length
| Max length | 14 |
|---|---|
| Median length | 11 |
| Mean length | 11.214286 |
| Min length | 11 |
Characters and Unicode
| Total characters | 1186920 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2016A000011124 |
|---|---|
| 2nd row | 2016A000011124 |
| 3rd row | 2016A000011124 |
| 4th row | 2016A000011124 |
| 5th row | 2016A000011124 |
Common Values
| Value | Count | Frequency (%) |
| 2016A000011124 | 7560 | 7.1% |
| 2016A000210 | 7560 | 7.1% |
| 2016A000211 | 7560 | 7.1% |
| 2016A000212 | 7560 | 7.1% |
| 2016A000213 | 7560 | 7.1% |
| 2016A000224 | 7560 | 7.1% |
| 2016A000235 | 7560 | 7.1% |
| 2016A000246 | 7560 | 7.1% |
| 2016A000247 | 7560 | 7.1% |
| 2016A000248 | 7560 | 7.1% |
| Other values (4) | 30240 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 2016a000011124 | 7560 | 7.1% |
| 2016a000210 | 7560 | 7.1% |
| 2016a000211 | 7560 | 7.1% |
| 2016a000212 | 7560 | 7.1% |
| 2016a000213 | 7560 | 7.1% |
| 2016a000224 | 7560 | 7.1% |
| 2016a000235 | 7560 | 7.1% |
| 2016a000246 | 7560 | 7.1% |
| 2016a000247 | 7560 | 7.1% |
| 2016a000248 | 7560 | 7.1% |
| Other values (4) | 30240 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 446040 | |
| 2 | 234360 | |
| 1 | 173880 | 14.6% |
| 6 | 136080 | 11.5% |
| A | 105840 | 8.9% |
| 4 | 37800 | 3.2% |
| 3 | 15120 | 1.3% |
| 5 | 15120 | 1.3% |
| 7 | 7560 | 0.6% |
| 8 | 7560 | 0.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1081080 | |
| Uppercase Letter | 105840 | 8.9% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 446040 | |
| 2 | 234360 | |
| 1 | 173880 | 16.1% |
| 6 | 136080 | 12.6% |
| 4 | 37800 | 3.5% |
| 3 | 15120 | 1.4% |
| 5 | 15120 | 1.4% |
| 7 | 7560 | 0.7% |
| 8 | 7560 | 0.7% |
| 9 | 7560 | 0.7% |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 105840 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1081080 | |
| Latin | 105840 | 8.9% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 446040 | |
| 2 | 234360 | |
| 1 | 173880 | 16.1% |
| 6 | 136080 | 12.6% |
| 4 | 37800 | 3.5% |
| 3 | 15120 | 1.4% |
| 5 | 15120 | 1.4% |
| 7 | 7560 | 0.7% |
| 8 | 7560 | 0.7% |
| 9 | 7560 | 0.7% |
Latin
| Value | Count | Frequency (%) |
| A | 105840 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1186920 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 446040 | |
| 2 | 234360 | |
| 1 | 173880 | 14.6% |
| 6 | 136080 | 11.5% |
| A | 105840 | 8.9% |
| 4 | 37800 | 3.2% |
| 3 | 15120 | 1.3% |
| 5 | 15120 | 1.3% |
| 7 | 7560 | 0.6% |
| 8 | 7560 | 0.6% |
GEO
Categorical
HIGH CORRELATION UNIFORM
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 827.0 KiB |
| Canada | |
|---|---|
| Newfoundland and Labrador | |
| Prince Edward Island | |
| Nova Scotia | |
| New Brunswick | |
| Other values (9) |
Length
| Max length | 25 |
|---|---|
| Median length | 14.5 |
| Mean length | 11.714286 |
| Min length | 5 |
Characters and Unicode
| Total characters | 1239840 |
|---|---|
| Distinct characters | 34 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Canada |
|---|---|
| 2nd row | Canada |
| 3rd row | Canada |
| 4th row | Canada |
| 5th row | Canada |
Common Values
| Value | Count | Frequency (%) |
| Canada | 7560 | 7.1% |
| Newfoundland and Labrador | 7560 | 7.1% |
| Prince Edward Island | 7560 | 7.1% |
| Nova Scotia | 7560 | 7.1% |
| New Brunswick | 7560 | 7.1% |
| Quebec | 7560 | 7.1% |
| Ontario | 7560 | 7.1% |
| Manitoba | 7560 | 7.1% |
| Saskatchewan | 7560 | 7.1% |
| Alberta | 7560 | 7.1% |
| Other values (4) | 30240 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| canada | 7560 | 4.5% |
| newfoundland | 7560 | 4.5% |
| territories | 7560 | 4.5% |
| northwest | 7560 | 4.5% |
| yukon | 7560 | 4.5% |
| columbia | 7560 | 4.5% |
| british | 7560 | 4.5% |
| alberta | 7560 | 4.5% |
| saskatchewan | 7560 | 4.5% |
| manitoba | 7560 | 4.5% |
| Other values (12) | 90720 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 151200 | 12.2% |
| n | 90720 | 7.3% |
| r | 90720 | 7.3% |
| t | 75600 | 6.1% |
| e | 75600 | 6.1% |
| o | 75600 | 6.1% |
| i | 75600 | 6.1% |
| d | 60480 | 4.9% |
| 60480 | 4.9% | |
| u | 52920 | 4.3% |
| Other values (24) | 430920 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1020600 | |
| Uppercase Letter | 158760 | 12.8% |
| Space Separator | 60480 | 4.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 151200 | |
| n | 90720 | 8.9% |
| r | 90720 | 8.9% |
| t | 75600 | 7.4% |
| e | 75600 | 7.4% |
| o | 75600 | 7.4% |
| i | 75600 | 7.4% |
| d | 60480 | 5.9% |
| u | 52920 | 5.2% |
| s | 45360 | 4.4% |
| Other values (9) | 226800 |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 37800 | |
| B | 15120 | 9.5% |
| S | 15120 | 9.5% |
| C | 15120 | 9.5% |
| I | 7560 | 4.8% |
| E | 7560 | 4.8% |
| P | 7560 | 4.8% |
| L | 7560 | 4.8% |
| Q | 7560 | 4.8% |
| O | 7560 | 4.8% |
| Other values (4) | 30240 |
Space Separator
| Value | Count | Frequency (%) |
| 60480 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1179360 | |
| Common | 60480 | 4.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 151200 | 12.8% |
| n | 90720 | 7.7% |
| r | 90720 | 7.7% |
| t | 75600 | 6.4% |
| e | 75600 | 6.4% |
| o | 75600 | 6.4% |
| i | 75600 | 6.4% |
| d | 60480 | 5.1% |
| u | 52920 | 4.5% |
| s | 45360 | 3.8% |
| Other values (23) | 385560 |
Common
| Value | Count | Frequency (%) |
| 60480 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1239840 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 151200 | 12.2% |
| n | 90720 | 7.3% |
| r | 90720 | 7.3% |
| t | 75600 | 6.1% |
| e | 75600 | 6.1% |
| o | 75600 | 6.1% |
| i | 75600 | 6.1% |
| d | 60480 | 4.9% |
| 60480 | 4.9% | |
| u | 52920 | 4.3% |
| Other values (24) | 430920 |
Sector
Categorical
UNIFORM
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 827.0 KiB |
| Total non-profit institutions | |
|---|---|
| Total non-profit institutions excluding governments | |
| Non-profit institutions serving households (community organizations) | |
| Business non-profit institutions | |
| Government non-profit institutions |
Length
| Max length | 68 |
|---|---|
| Median length | 34 |
| Mean length | 42.8 |
| Min length | 29 |
Characters and Unicode
| Total characters | 4529952 |
|---|---|
| Distinct characters | 29 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Total non-profit institutions |
|---|---|
| 2nd row | Total non-profit institutions |
| 3rd row | Total non-profit institutions |
| 4th row | Total non-profit institutions |
| 5th row | Total non-profit institutions |
Common Values
| Value | Count | Frequency (%) |
| Total non-profit institutions | 21168 | |
| Total non-profit institutions excluding governments | 21168 | |
| Non-profit institutions serving households (community organizations) | 21168 | |
| Business non-profit institutions | 21168 | |
| Government non-profit institutions | 21168 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| non-profit | 105840 | |
| institutions | 105840 | |
| total | 42336 | 10.0% |
| excluding | 21168 | 5.0% |
| governments | 21168 | 5.0% |
| serving | 21168 | 5.0% |
| households | 21168 | 5.0% |
| community | 21168 | 5.0% |
| organizations | 21168 | 5.0% |
| business | 21168 | 5.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 613872 | |
| i | 550368 | |
| t | 550368 | |
| o | 508032 | |
| s | 381024 | 8.4% |
| 317520 | 7.0% | |
| r | 190512 | 4.2% |
| u | 190512 | 4.2% |
| e | 169344 | 3.7% |
| f | 105840 | 2.3% |
| Other values (19) | 952560 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 3958416 | |
| Space Separator | 317520 | 7.0% |
| Dash Punctuation | 105840 | 2.3% |
| Uppercase Letter | 105840 | 2.3% |
| Open Punctuation | 21168 | 0.5% |
| Close Punctuation | 21168 | 0.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 613872 | |
| i | 550368 | |
| t | 550368 | |
| o | 508032 | |
| s | 381024 | |
| r | 190512 | 4.8% |
| u | 190512 | 4.8% |
| e | 169344 | 4.3% |
| f | 105840 | 2.7% |
| p | 105840 | 2.7% |
| Other values (11) | 592704 |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 42336 | |
| N | 21168 | |
| B | 21168 | |
| G | 21168 |
Space Separator
| Value | Count | Frequency (%) |
| 317520 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 105840 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 21168 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 21168 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4064256 | |
| Common | 465696 | 10.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 613872 | |
| i | 550368 | |
| t | 550368 | |
| o | 508032 | |
| s | 381024 | |
| r | 190512 | 4.7% |
| u | 190512 | 4.7% |
| e | 169344 | 4.2% |
| f | 105840 | 2.6% |
| p | 105840 | 2.6% |
| Other values (15) | 698544 |
Common
| Value | Count | Frequency (%) |
| 317520 | ||
| - | 105840 | 22.7% |
| ( | 21168 | 4.5% |
| ) | 21168 | 4.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4529952 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 613872 | |
| i | 550368 | |
| t | 550368 | |
| o | 508032 | |
| s | 381024 | 8.4% |
| 317520 | 7.0% | |
| r | 190512 | 4.2% |
| u | 190512 | 4.2% |
| e | 169344 | 3.7% |
| f | 105840 | 2.3% |
| Other values (19) | 952560 |
Characteristics
Categorical
UNIFORM
| Distinct | 18 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 827.0 KiB |
| Male employees | 5880 |
|---|---|
| Female employees | 5880 |
| Immigrant employees | 5880 |
| Non-immigrant employees | 5880 |
| Indigenous identity employees | 5880 |
| Other values (13) |
Length
| Max length | 33 |
|---|---|
| Median length | 28 |
| Mean length | 19.5 |
| Min length | 14 |
Characters and Unicode
| Total characters | 2063880 |
|---|---|
| Distinct characters | 37 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Male employees |
|---|---|
| 2nd row | Male employees |
| 3rd row | Male employees |
| 4th row | Male employees |
| 5th row | Male employees |
Common Values
| Value | Count | Frequency (%) |
| Male employees | 5880 | 5.6% |
| Female employees | 5880 | 5.6% |
| Immigrant employees | 5880 | 5.6% |
| Non-immigrant employees | 5880 | 5.6% |
| Indigenous identity employees | 5880 | 5.6% |
| Non-indigenous identity employees | 5880 | 5.6% |
| Visible minority | 5880 | 5.6% |
| Not a visible minority | 5880 | 5.6% |
| High school diploma and less | 5880 | 5.6% |
| Trade certificate | 5880 | 5.6% |
| Other values (8) | 47040 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| employees | 35280 | 10.3% |
| years | 35280 | 10.3% |
| to | 29400 | 8.6% |
| and | 17640 | 5.2% |
| identity | 11760 | 3.4% |
| visible | 11760 | 3.4% |
| minority | 11760 | 3.4% |
| diploma | 11760 | 3.4% |
| male | 5880 | 1.7% |
| 34 | 5880 | 1.7% |
| Other values (28) | 164640 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 264600 | |
| 235200 | 11.4% | |
| i | 152880 | 7.4% |
| o | 147000 | 7.1% |
| s | 117600 | 5.7% |
| a | 105840 | 5.1% |
| l | 99960 | 4.8% |
| y | 99960 | 4.8% |
| t | 99960 | 4.8% |
| r | 94080 | 4.6% |
| Other values (27) | 646800 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1617000 | |
| Space Separator | 235200 | 11.4% |
| Decimal Number | 129360 | 6.3% |
| Uppercase Letter | 70560 | 3.4% |
| Dash Punctuation | 11760 | 0.6% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 264600 | |
| i | 152880 | |
| o | 147000 | |
| s | 117600 | 7.3% |
| a | 105840 | 6.5% |
| l | 99960 | 6.2% |
| y | 99960 | 6.2% |
| t | 99960 | 6.2% |
| r | 94080 | 5.8% |
| n | 94080 | 5.8% |
| Other values (10) | 341040 |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 17640 | |
| I | 11760 | |
| H | 5880 | 8.3% |
| T | 5880 | 8.3% |
| C | 5880 | 8.3% |
| U | 5880 | 8.3% |
| V | 5880 | 8.3% |
| F | 5880 | 8.3% |
| M | 5880 | 8.3% |
Decimal Number
| Value | Count | Frequency (%) |
| 5 | 47040 | |
| 4 | 41160 | |
| 2 | 11760 | 9.1% |
| 3 | 11760 | 9.1% |
| 6 | 11760 | 9.1% |
| 1 | 5880 | 4.5% |
Space Separator
| Value | Count | Frequency (%) |
| 235200 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 11760 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1687560 | |
| Common | 376320 | 18.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 264600 | |
| i | 152880 | 9.1% |
| o | 147000 | 8.7% |
| s | 117600 | 7.0% |
| a | 105840 | 6.3% |
| l | 99960 | 5.9% |
| y | 99960 | 5.9% |
| t | 99960 | 5.9% |
| r | 94080 | 5.6% |
| n | 94080 | 5.6% |
| Other values (19) | 411600 |
Common
| Value | Count | Frequency (%) |
| 235200 | ||
| 5 | 47040 | 12.5% |
| 4 | 41160 | 10.9% |
| 2 | 11760 | 3.1% |
| 3 | 11760 | 3.1% |
| - | 11760 | 3.1% |
| 6 | 11760 | 3.1% |
| 1 | 5880 | 1.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2063880 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 264600 | |
| 235200 | 11.4% | |
| i | 152880 | 7.4% |
| o | 147000 | 7.1% |
| s | 117600 | 5.7% |
| a | 105840 | 5.1% |
| l | 99960 | 4.8% |
| y | 99960 | 4.8% |
| t | 99960 | 4.8% |
| r | 94080 | 4.6% |
| Other values (27) | 646800 |
Indicators
Categorical
HIGH CORRELATION UNIFORM
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 827.0 KiB |
| Number of jobs | |
|---|---|
| Hours worked | |
| Wages and salaries | |
| Average annual hours worked | |
| Average weekly hours worked | |
| Other values (2) |
Length
| Max length | 33 |
|---|---|
| Median length | 19 |
| Mean length | 21.428571 |
| Min length | 12 |
Characters and Unicode
| Total characters | 2268000 |
|---|---|
| Distinct characters | 25 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Number of jobs |
|---|---|
| 2nd row | Hours worked |
| 3rd row | Wages and salaries |
| 4th row | Average annual hours worked |
| 5th row | Average weekly hours worked |
Common Values
| Value | Count | Frequency (%) |
| Number of jobs | 15120 | |
| Hours worked | 15120 | |
| Wages and salaries | 15120 | |
| Average annual hours worked | 15120 | |
| Average weekly hours worked | 15120 | |
| Average annual wages and salaries | 15120 | |
| Average hourly wage | 15120 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| average | 60480 | |
| hours | 45360 | |
| worked | 45360 | |
| wages | 30240 | |
| and | 30240 | |
| salaries | 30240 | |
| annual | 30240 | |
| number | 15120 | 4.2% |
| of | 15120 | 4.2% |
| jobs | 15120 | 4.2% |
| Other values (3) | 45360 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 287280 | |
| a | 257040 | |
| 257040 | ||
| r | 211680 | 9.3% |
| s | 151200 | 6.7% |
| o | 136080 | 6.0% |
| u | 105840 | 4.7% |
| g | 105840 | 4.7% |
| n | 90720 | 4.0% |
| l | 90720 | 4.0% |
| Other values (15) | 574560 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1905120 | |
| Space Separator | 257040 | 11.3% |
| Uppercase Letter | 105840 | 4.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 287280 | |
| a | 257040 | |
| r | 211680 | |
| s | 151200 | 7.9% |
| o | 136080 | 7.1% |
| u | 105840 | 5.6% |
| g | 105840 | 5.6% |
| n | 90720 | 4.8% |
| l | 90720 | 4.8% |
| w | 90720 | 4.8% |
| Other values (10) | 378000 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 60480 | |
| W | 15120 | 14.3% |
| H | 15120 | 14.3% |
| N | 15120 | 14.3% |
Space Separator
| Value | Count | Frequency (%) |
| 257040 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2010960 | |
| Common | 257040 | 11.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 287280 | |
| a | 257040 | |
| r | 211680 | |
| s | 151200 | 7.5% |
| o | 136080 | 6.8% |
| u | 105840 | 5.3% |
| g | 105840 | 5.3% |
| n | 90720 | 4.5% |
| l | 90720 | 4.5% |
| w | 90720 | 4.5% |
| Other values (14) | 483840 |
Common
| Value | Count | Frequency (%) |
| 257040 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2268000 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 287280 | |
| a | 257040 | |
| 257040 | ||
| r | 211680 | 9.3% |
| s | 151200 | 6.7% |
| o | 136080 | 6.0% |
| u | 105840 | 4.7% |
| g | 105840 | 4.7% |
| n | 90720 | 4.0% |
| l | 90720 | 4.0% |
| Other values (15) | 574560 |
UOM
Categorical
HIGH CORRELATION
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 827.0 KiB |
| Hours | |
|---|---|
| Dollars | |
| Jobs |
Length
| Max length | 7 |
|---|---|
| Median length | 5 |
| Mean length | 5.7142857 |
| Min length | 4 |
Characters and Unicode
| Total characters | 604800 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Jobs |
|---|---|
| 2nd row | Hours |
| 3rd row | Dollars |
| 4th row | Hours |
| 5th row | Hours |
Common Values
| Value | Count | Frequency (%) |
| Hours | 45360 | |
| Dollars | 45360 | |
| Jobs | 15120 | 14.3% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| hours | 45360 | |
| dollars | 45360 | |
| jobs | 15120 | 14.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 105840 | |
| s | 105840 | |
| r | 90720 | |
| l | 90720 | |
| H | 45360 | |
| u | 45360 | |
| D | 45360 | |
| a | 45360 | |
| J | 15120 | 2.5% |
| b | 15120 | 2.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 498960 | |
| Uppercase Letter | 105840 | 17.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 105840 | |
| s | 105840 | |
| r | 90720 | |
| l | 90720 | |
| u | 45360 | |
| a | 45360 | |
| b | 15120 | 3.0% |
Uppercase Letter
| Value | Count | Frequency (%) |
| H | 45360 | |
| D | 45360 | |
| J | 15120 | 14.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 604800 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 105840 | |
| s | 105840 | |
| r | 90720 | |
| l | 90720 | |
| H | 45360 | |
| u | 45360 | |
| D | 45360 | |
| a | 45360 | |
| J | 15120 | 2.5% |
| b | 15120 | 2.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 604800 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 105840 | |
| s | 105840 | |
| r | 90720 | |
| l | 90720 | |
| H | 45360 | |
| u | 45360 | |
| D | 45360 | |
| a | 45360 | |
| J | 15120 | 2.5% |
| b | 15120 | 2.5% |
SCALAR_FACTOR
Categorical
HIGH CORRELATION
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 827.0 KiB |
| units | |
|---|---|
| thousands | |
| millions |
Length
| Max length | 9 |
|---|---|
| Median length | 5 |
| Mean length | 6 |
| Min length | 5 |
Characters and Unicode
| Total characters | 635040 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | units |
|---|---|
| 2nd row | thousands |
| 3rd row | millions |
| 4th row | units |
| 5th row | units |
Common Values
| Value | Count | Frequency (%) |
| units | 75600 | |
| thousands | 15120 | 14.3% |
| millions | 15120 | 14.3% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| units | 75600 | |
| thousands | 15120 | 14.3% |
| millions | 15120 | 14.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 120960 | |
| n | 105840 | |
| i | 105840 | |
| u | 90720 | |
| t | 90720 | |
| o | 30240 | 4.8% |
| l | 30240 | 4.8% |
| h | 15120 | 2.4% |
| a | 15120 | 2.4% |
| d | 15120 | 2.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 635040 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| s | 120960 | |
| n | 105840 | |
| i | 105840 | |
| u | 90720 | |
| t | 90720 | |
| o | 30240 | 4.8% |
| l | 30240 | 4.8% |
| h | 15120 | 2.4% |
| a | 15120 | 2.4% |
| d | 15120 | 2.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 635040 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| s | 120960 | |
| n | 105840 | |
| i | 105840 | |
| u | 90720 | |
| t | 90720 | |
| o | 30240 | 4.8% |
| l | 30240 | 4.8% |
| h | 15120 | 2.4% |
| a | 15120 | 2.4% |
| d | 15120 | 2.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 635040 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| s | 120960 | |
| n | 105840 | |
| i | 105840 | |
| u | 90720 | |
| t | 90720 | |
| o | 30240 | 4.8% |
| l | 30240 | 4.8% |
| h | 15120 | 2.4% |
| a | 15120 | 2.4% |
| d | 15120 | 2.4% |
VALUE
Real number (ℝ)
MISSING
| Distinct | 35398 |
|---|---|
| Distinct (%) | 34.4% |
| Missing | 3024 |
| Missing (%) | 2.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26419.543 |
| Minimum | 0 |
|---|---|
| Maximum | 3857813 |
| Zeros | 9 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 827.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 18.6075 |
| Q1 | 32 |
| median | 1386 |
| Q3 | 17660 |
| 95-th percentile | 85576.5 |
| Maximum | 3857813 |
| Range | 3857813 |
| Interquartile range (IQR) | 17628 |
Descriptive statistics
| Standard deviation | 118041.35 |
|---|---|
| Coefficient of variation (CV) | 4.4679558 |
| Kurtosis | 266.93641 |
| Mean | 26419.543 |
| Median Absolute Deviation (MAD) | 1358 |
| Skewness | 13.831207 |
| Sum | 2.7163518 × 109 |
| Variance | 1.393376 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 30 | 2040 | 1.9% |
| 31 | 1949 | 1.8% |
| 32 | 1844 | 1.7% |
| 29 | 1562 | 1.5% |
| 33 | 1476 | 1.4% |
| 34 | 1005 | 0.9% |
| 28 | 905 | 0.9% |
| 35 | 638 | 0.6% |
| 27 | 523 | 0.5% |
| 36 | 457 | 0.4% |
| Other values (35388) | 90417 | |
| (Missing) | 3024 | 2.9% |
| Value | Count | Frequency (%) |
| 0 | 9 | < 0.1% |
| 1 | 219 | |
| 2 | 299 | |
| 3 | 201 | |
| 4 | 203 | |
| 5 | 157 | |
| 6 | 147 | |
| 7 | 135 | |
| 8 | 179 | |
| 9 | 145 |
| Value | Count | Frequency (%) |
| 3857813 | 1 | |
| 3690238 | 1 | |
| 3643952 | 1 | |
| 3581317 | 1 | |
| 3556730 | 1 | |
| 3544822 | 1 | |
| 3487265 | 1 | |
| 3425218 | 1 | |
| 3402343 | 1 | |
| 3372266 | 1 |
| REF_DATE | VALUE | DGUID | GEO | Sector | Characteristics | Indicators | UOM | SCALAR_FACTOR | |
|---|---|---|---|---|---|---|---|---|---|
| REF_DATE | 1.000 | 0.027 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| VALUE | 0.027 | 1.000 | 0.090 | 0.090 | 0.051 | 0.044 | 0.075 | 0.081 | 0.105 |
| DGUID | 0.000 | 0.090 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| GEO | 0.000 | 0.090 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| Sector | 0.000 | 0.051 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| Characteristics | 0.000 | 0.044 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 |
| Indicators | 0.000 | 0.075 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 1.000 | 1.000 |
| UOM | 0.000 | 0.081 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 1.000 | 0.447 |
| SCALAR_FACTOR | 0.000 | 0.105 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.447 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| REF_DATE | DGUID | GEO | Sector | Characteristics | Indicators | UOM | SCALAR_FACTOR | VALUE | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | 2010 | 2016A000011124 | Canada | Total non-profit institutions | Male employees | Number of jobs | Jobs | units | 642584.00 |
| 1 | 2010 | 2016A000011124 | Canada | Total non-profit institutions | Male employees | Hours worked | Hours | thousands | 1048516.00 |
| 2 | 2010 | 2016A000011124 | Canada | Total non-profit institutions | Male employees | Wages and salaries | Dollars | millions | 30805.00 |
| 3 | 2010 | 2016A000011124 | Canada | Total non-profit institutions | Male employees | Average annual hours worked | Hours | units | 1632.00 |
| 4 | 2010 | 2016A000011124 | Canada | Total non-profit institutions | Male employees | Average weekly hours worked | Hours | units | 31.00 |
| 5 | 2010 | 2016A000011124 | Canada | Total non-profit institutions | Male employees | Average annual wages and salaries | Dollars | units | 47940.00 |
| 6 | 2010 | 2016A000011124 | Canada | Total non-profit institutions | Male employees | Average hourly wage | Dollars | units | 29.38 |
| 7 | 2010 | 2016A000011124 | Canada | Total non-profit institutions | Female employees | Number of jobs | Jobs | units | 1500394.00 |
| 8 | 2010 | 2016A000011124 | Canada | Total non-profit institutions | Female employees | Hours worked | Hours | thousands | 2331018.00 |
| 9 | 2010 | 2016A000011124 | Canada | Total non-profit institutions | Female employees | Wages and salaries | Dollars | millions | 60943.00 |
| REF_DATE | DGUID | GEO | Sector | Characteristics | Indicators | UOM | SCALAR_FACTOR | VALUE | |
|---|---|---|---|---|---|---|---|---|---|
| 105830 | 2021 | 2016A000262 | Nunavut | Government non-profit institutions | 55 to 64 years | Average weekly hours worked | Hours | units | 33.00 |
| 105831 | 2021 | 2016A000262 | Nunavut | Government non-profit institutions | 55 to 64 years | Average annual wages and salaries | Dollars | units | 101380.00 |
| 105832 | 2021 | 2016A000262 | Nunavut | Government non-profit institutions | 55 to 64 years | Average hourly wage | Dollars | units | 59.98 |
| 105833 | 2021 | 2016A000262 | Nunavut | Government non-profit institutions | 65 years old and over | Number of jobs | Jobs | units | 27.00 |
| 105834 | 2021 | 2016A000262 | Nunavut | Government non-profit institutions | 65 years old and over | Hours worked | Hours | thousands | 30.00 |
| 105835 | 2021 | 2016A000262 | Nunavut | Government non-profit institutions | 65 years old and over | Wages and salaries | Dollars | millions | 2.00 |
| 105836 | 2021 | 2016A000262 | Nunavut | Government non-profit institutions | 65 years old and over | Average annual hours worked | Hours | units | 1111.00 |
| 105837 | 2021 | 2016A000262 | Nunavut | Government non-profit institutions | 65 years old and over | Average weekly hours worked | Hours | units | 21.00 |
| 105838 | 2021 | 2016A000262 | Nunavut | Government non-profit institutions | 65 years old and over | Average annual wages and salaries | Dollars | units | 74037.00 |
| 105839 | 2021 | 2016A000262 | Nunavut | Government non-profit institutions | 65 years old and over | Average hourly wage | Dollars | units | 66.63 |